2014-10-02 - 14813 - Spec - Create a data source from shipped orders #BExQueriesforCrystalReportsAnalysisTool

SPECIFICATION

14813 - Create a data source from shipped orders

Requirement Summary

---

Need to create a query from the shipped data source for Analysis.

Admin Info

---

Purpose	Need to create a query from the shipped data source for Analysis.
Requested By	Todd Sokolowski
Spec Created By	Chandramouli K
Spec Created Date	10/02/2014
Spec QA by	Chandramouli K
Objects	VIC_SHIP_Q001
Document Status	Complete

Estimates

---

SNo	Activity	Estimation in Hours
1	Research	01
2	Documentation	01
3	Development/ Config	04
4	Unit test in DEV	02
5	Unit test in QUA	00
6	Other activity	00
	TOTAL	08

References

---

Prior Tickets

None

Documents

None

Spec Changes

---

SNo	Change Details	Requested By	Requested On	Notes if any

Functional Requirement

---

Purpose/WHY:

Need to create the BEx query in BPD(BW 7.3 Development) system and transport it to BPQ(BW 7.3 Quality) and BPP(BW 7.3 Production).

In Scope:

BEx Query for Analysis view.

Out of Scope:

None

Solution Summary

---

1. Need to create a BEx Query in BPD.
2. Need to maintain required Characteristics, Key Figures and other query properties as per the requirement.
3. Check the BEx query for QA Standards.
4. Unit test and transport it to BPQ.

Test Plan

SNo	Test Scenario	Expected Results
1.	Check the BEx query against NEC Standard BEx checklist.	BEx query should pass all test cases as per NEC standard checklist.
2	Test the BEx query functionality in BPQ.	Query should be successfully validated in BPQ.

Solution Details

---

1. Need to create a BEx Query in BPD(BW 7.3 Development) as per standard naming convention.
2. Need to maintain required Characteristics, Key Figures and other query properties as per the NEC requirement.
3. Check the BEx query for QA Standards against the NEC standard checklist and for consistent data.
4. Unit Test the query and then transport it to BPQ for further detailed testing.

Issues

---

None